www.gusucode.com > PHP版 QQ聊天机器人源码 V3.2PHP源码程序 > PHP版 QQ聊天机器人源码 V3.2/Itpk_V3.2_Zip/Itpk_V3.2_Zip/class/per/WebchatroomPer.php
<?php if (!defined('ITPK')) exit('You can not directly access the file.'); /** * 聊天室操作类 * @author 冬天的秘密 * @link http://bbs.itpk.cn * @version 1.0 */ class WebchatroomPer extends WebDBConnection { private $table = "web_chat_room"; /** * 获取所有的聊天室 * @return array */ public function getMeAll() { $selectSql = new SelectSql($this->table); $selectSql->setOrder("id", "ASC"); return $selectSql->executeSelectSql($this->db, true); } /** * 根据聊天室ID获取信息 * @param int $id */ public function getMeById($id) { $selectSql = new SelectSql($this->table); $selectSql->setWhere("id", $id); $selectSql->setLimitAndOffset(); return $selectSql->executeSelectSql($this->db); } /** * 添加聊天室 * @param string $name * @return boolean */ public function insertMe($name) { $insertSql = new InsertSql($this->table); $columnArray = array( "name", "createdate" ); $columnValueArray = array( $name, time() ); $insertSql->setInsert($columnArray, $columnValueArray); return $insertSql->executeInsertSql($this->db); } /** * 删除聊天室 * @param int $id */ public function deleteMe($id) { $deleteSql = new DeleteSql($this->table); $deleteSql->setWhere("id", $id); return $deleteSql->executeDeleteSql($this->db); } /** * 修改聊天室 * @param int $id * @param string $name * @return boolean */ public function updateMe($id, $name) { $updateSql = new UpdateSql($this->table); $updateSql->setUpdateValue("name", $name); $updateSql->setWhere("id", $id); return $updateSql->executeUpdateSql($this->db); } } ?>